Aside

Michael Hanna

Contact Info

Personal Statement

My engineering background, rig experience, and strong computer skills enable me to understand the business needs and data flows to create user-friendly and efficient solutions that cover the data life cycle from data capturing, data quality control, data extraction and manipulation, data visualization, and data analysis.

Skills

  • Proficient with SQL Scripting
  • Proficient with TIBCO Spotfire
  • Proficient with Excel and VBA Programming

Main

Michael Hanna

Data Engineer

Professional Experience

Data Engineer II

EQT Corporation

Pittsburgh, PA

Jun 2017 - Current

  • Write R and SQL scripts to Extract, Transform, and Load data (ETL) from the authoritative sources to enable data-driven decisions for the business.
  • Develop insights using Tibco Spotfire, Microsoft Power BI, and R Shiny as needed.
  • Report quarterly drilling performance and KPIs to the management.
  • Create and deploy all Wellview drilling data audits to ensure data reliability.
  • Manage work using cases and work items in Salesforce and repositories in Github.

Wells Performance Analyst

BP

Anchorage, Alaska

Apr 2012 - May 2017

  • Develop Excel automated tools using VBA for end of well reporting, wellbore integrity testing calculator, score card, and data audits.
  • Provide support to the drilling and workover teams by responding to ad-hoc data requests, answering questions, and providing analysis.
  • Act as Landmark applications point of contact for OpenWells, Compass, and Data Analyzer.
  • Create and maintain GWO (Global Wells Organization) Spotfire dashboards.
  • Compile and manipulate data from different sources to assist with technical analysis (EDM, AWGRS, Finder, SAP Business Objects,…etc.)
  • Assist in Drilling Performance Benchmarking and KPIs.
  • Update the company legacy tools to comply with the new policies and best practices.

Senior Drilling Data Management Engineer

MCS Freezone (Modern Computing Services)

Cairo, Egypt

Mar 2006 - Sep 2011

  • Research, design, install, configure, troubleshoot, train, and support MCS drilling applications.
  • Report the Drilling Performance, NPT, root cause analysis, and learn curve management.
  • Support the data acquisition, data entry, data QC, and end of well reporting.
  • Implement the first Kongsberg real-time drilling data management system in the Egyptian market.
  • Install and run PMAC sand monitoring system on offshore rig in Mauritania.

Roughneck

Global SantaFE Corporation, Offshore Key Manhattan Jackup Rig

Port Said, Egypt

Nov 2004 - Feb 2006

DRILLING APPS

  • Proficient with Landmark EDM Suite (OpenWells, Compass, Data Analyzer, and Profile)

  • Proficient with Peloton Wellview

  • Proficient with Petrobeacon Spotlight Audit App

  • Proficient with Genesis Analyzer, Designer and Data Entry System (DES)

  • Proficient with the Drilling Performance KPIs and End of Well Reporting


SKILLS ACTIVELY LEARNING

  • Python
  • Azure Data Factory, Data Lake, and Databricks
  • Power BI and DAX Language
  • R (purrr, magrittr, timevis, leaflet, plotly, zoo, reticulate, and data.table)

REFERENCES

Scan this with your iPhone camera to look at recommendations on my LinkedIn profile.




This resume was created using the R package pagedown.


Last updated on 2020-02-18

Education

Cairo University - Faculty of Engineering

B.Sc. in Petroleum Engineering

Cairo, Egypt

1998 - 2003

Selected achievements

EQT

N/A

N/A

N/A

  • Developed ‘write_2_azure’ function in R to QC the written data frames prior to truncating existing tables by adding proper error handling techniques and logging the errors in the relevant database. This prevented erroneous data to be fed downstream and improved the stability of our scripts. The function was later promoted in the company package for the general consumption.
  • Automated weekly emails pulling data from Azure SQL database and sending them to joint-venture partners using R.
  • Created a Drilling Sandbox which is an interactive Spotfire dashboard taking inputs from the user to tweak the settings and axes to answer endless performance questions which ended, multiple times, On the earning call presentations.

BP

N/A

N/A

N/A

  • Developed and maintained the first Spotfire dashboards in GWO Alaska. Received global recognition from BP.
  • Created “Wellbore Integrity Testing Criteria Calculator” which determines if the test pressure results meet the acceptance criteria according to “BP Site Technical Practice CRT-AK-10-45: Working with Pressure”.

EGYPT

N/A

N/A

N/A

  • Awarded a certificate for my successful participation in the “In-House SPE Student Technical Paper Contest”, Cairo, Egypt, 2003.